Excel Data Analysis For Dummies by Paul McFedries

Author:Paul McFedries
Language: eng
Format: epub
ISBN: 9781119518228
Publisher: Wiley
Published: 2018-11-06T00:00:00+00:00

When you add a calculated field to the PivotTable, Excel also applies the custom calculation to the Grand Total value (refer to Figure 8-13). Unfortunately, this total is often inaccurate, and you should be careful not to assume that it’s correct. The problem is that it’s not a sum of the values in the calculated field, as you might think. Instead, Excel applies the calculated field’s formula to the sum of whatever field or fields you referenced in the formula. In the example shown in Figure 8-13, Excel applies the formula to the Sum of Extended Price field’s Grand Total value, which is not the correct way to calculate the total commission. If you want to see the correct total for the calculated field, set up a formula outside the PivotTable that sums the values.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.